SELECT `t`.`name` `pricetable_name`, `t`.`term_id` `pricetable`, `r`.`id` `resellerid` , `p`.`uri`, `p`.`affiliate_link`, `p`.`uid1`, `p`.`uid2`, `a`.`name` as affiliate_name FROM `wpfn_terms` `t` INNER JOIN `wpfn_afp_prices` `p` ON `p`.`tableid` = `t`.`term_id` INNER JOIN `wpfn_afp_resellers` `r` ON `r`.`id` = `p`.`resellerid` INNER JOIN `wpfn_afp_affiliates` `a` ON `a`.`id` = `r`.`affiliate` WHERE CONCAT( `t`.`slug`, '/', `r`.`slug`) = 'ringsted-dun-nightingale-550g-dundyne-hvid-200x140cm/Erling{7c90e2647b1c7e6fe6dceeeb01d1f2d415246c5ffec07eb83e0f0dbfe3c31306}20Christensen{7c90e2647b1c7e6fe6dceeeb01d1f2d415246c5ffec07eb83e0f0dbfe3c31306}20M{7c90e2647b1c7e6fe6dceeeb01d1f2d415246c5ffec07eb83e0f0dbfe3c31306}C3{7c90e2647b1c7e6fe6dceeeb01d1f2d415246c5ffec07eb83e0f0dbfe3c31306}B8bler/__pr'